select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseArea >= 0 and a.houseArea <= 100) and (b.cnpropertyname like '%North Xiangyang Rd Old House%' or b.enpropertyname like '%North Xiangyang Rd Old House%') order by updateTime Desc, a.dftpic desc
Located at the top position of the Mid Huaihai Rd Area. This recently renovated two bedroom paradise has an easy access to the subway, shopping, restaurants, a...